from app.lib.MysqlPool import MysqlPool
config={}
config['DBHOST'] = '192.168.70.3'
config['DBPORT'] = 3306
config['DBUSER'] = 'user_test'
config['DBNAME'] = 'fcp2db_uat'
config['DBPWD'] = '1107'
config['DBCHAR'] = 'utf8'

pool = MysqlPool(config=config)

sqlAll = "select * from fcp2db_uat.vaccount_transfer_info order by vaccount_transfer_info.apply_time desc limit 100;"
result = pool.getAll(sqlAll)
if result :
    print("get all")
    for row in result :
        print(row)
pool.dispose()

